package com.hawthorn.redis.repository.provider;

import com.hawthorn.component.constant.DicConstant;
import org.apache.ibatis.builder.annotation.ProviderMethodResolver;

/**
 * <p>todo todo 公司缓存sql类</p>
 * @author: andyten@tom.com | xukaixing@hotmail.com
 * @created: 2022/06/30 12:59 PM
 * @version v1.0.1
 * @copyright: Copyright (c)  andyten
 */
public class CompanyCacheSqlProvider implements ProviderMethodResolver
{
  public static String selectCompany()
  {
    String sql = "select  " +
        "id, " +
        "code, " +
        "cname, " +
        "sname, " +
        "address, " +
        "contact, " +
        "legal_person, " +
        "invoice_name, " +
        "type, " +
        "kind " +
        "biz_type, " +
        "status, " +
        "oem_company_id " +
        "from sys_company " +
        "where del_flag = 0 " +
        " and status = " + DicConstant.YXBS_01 +
        " order by code";
    return sql;
  }
}
